import pandas as pd
import matplotlib.pyplot as plt
data = pd.read_excel('男子体能测试成绩.xlsx')
fig = plt.figure(figsize=(10,10))
fig1 = plt.subplot(2,2,1)
fig2 = plt.subplot(2,2,2)
fig3 = plt.subplot(2,2,3)
fig4 = plt.subplot(2,2,4)
fig1.scatter(data['1000米（分）'],data['成绩'],color = 'b',alpha = 0.6)
fig1.set_title('1000米项目用时与成绩的关系散点图')
fig1.set_xlabel('1000米项目用时（分）')
fig1.set_ylabel('成绩')
fig2.scatter(data['50米（秒）'],data['成绩'],color = 'g',alpha = 0.6)
fig2.set_title('50米项目用时与成绩的关系散点图')
fig1.set_xlabel('50米项目用时（秒）')
fig2.set_ylabel('成绩')
fig3.scatter(data['立定跳远（厘米)'],data['成绩'],color = 'r',alpha = 0.6)
fig3.set_title('立定跳远测试结果与成绩的关系散点图')
fig3.set_xlabel('立定跳远测试结果(厘米)')
fig3.set_ylabel('成绩')
fig4.scatter(data['坐位体前屈(厘米）'],data['成绩'],color = 'y',alpha = 0.6)
fig4.set_title('坐位体前屈测试结果与成绩的关系散点图')
fig4.set_xlabel('坐位体前屈测试结果(厘米)')
fig4.set_ylabel('成绩')
plt.subplots_adjust(hspace=0.3,wspace=0.2)
plt.rcParams['font.sans-serif']='SimHei'
plt.show()